package grsu.epam.airline.DAO;

import grsu.epam.airline.model.Employee;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface IEmployeeDAO {
	public void addEmployee(Employee employee) throws SQLException;

	public void updateEmployee(Employee employee) throws SQLException;

	public Employee getEmployeeById(int employeeId) throws SQLException;

	public void deleteEmployee(int employeeId) throws SQLException;

	public List<Employee> getAllEmployee() throws SQLException;

	public List<Employee> getEmployeesByFlightCrew(int flightCrewId)
			throws SQLException;

	public List<Employee> getEmployeesBySpeciality(int specialityId)
			throws SQLException;

	public Connection getConnection();

}
